/**********************************************************************/
/* QuickstartmembershipUsers.sql                                      */
/*                                                                    */
/* Create the default users for the PageFlow Quickstarts              */
/* Implementation                                                     */    
/*                                                                    */
/**********************************************************************/

PRINT '-----------------------------------------------------'
PRINT 'Starting execution of QuickstartmembershipUsers.sql  '
PRINT '-----------------------------------------------------'
GO

PRINT '-------------------------------------------------'
PRINT 'USERS                                            '
PRINT '-------------------------------------------------'
GO

DECLARE @currentUTCTime DATETIME,
        @newUserId UNIQUEIDENTIFIER

/* 'user' usera*/
SET @currentUTCTime = GETUTCDATE()
SET @newUserId = NEWID()

exec dbo.aspnet_Membership_CreateUser 
	@ApplicationName=N'PageFlow_Quickstart',
	@UserName=N'user',
	@Password=N'jolDqjQ3udAgdI/93Jc3mEDyw5Y=',
	@PasswordSalt=N'7WvYjRW6fCftLg+q8jWsSg==',
	@Email=N'user@quickstart.com',
	@PasswordQuestion=N'Favorite color',
	@PasswordAnswer=N'4cJ7lGKc3NFoC4J8uNJFDv01X6o=',
	@IsApproved=1,
	@UniqueEmail=1,
	@PasswordFormat=1,
	@CurrentTimeUtc= @currentUTCTime,
	@UserId=@newUserId 